<!--
    Copyright 2010 Justin Lipton, Jonathan Rosenberg
    
    This file is part of MediaList.

    MediaList is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    MediaList is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with MediaList.  If not, see <http://www.gnu.org/licenses/>.
-->

<html>
<script type="text/javascript" src="admin.js"></script>
<a href=index.php >Homepage</a><br/>
<?php
echo "<a href=profile.php?currentUser=".$_COOKIE["user"].">Profile page</a><br>";
echo "<a href=table.php?currentUser=".$_COOKIE["user"].">Table page</a><br>";
$con = mysql_connect("localhost", "root");
if (!$con)
{
    die('Could not connect: ' . mysql_error());
}
mysql_select_db("DB", $con);

$sql="SELECT Privileges FROM Users WHERE Username='".$_COOKIE["user"]."'";
$result = mysql_query($sql, $con);
$row = mysql_fetch_array($result);
if ($row['Privileges']=='A')//admin
{
    ?>
    <div id="showError" style="color:red"></div>
    <form onKeyPress="return submitenter(this, event, name1.value)">
    Delete a user: <input type="text" name="name1" />
    </form>
    <?php
    echo "Total number of Users=";
    $sql="SELECT count(*) FROM USERS";
    $result = mysql_query($sql, $con);
    $row = mysql_fetch_array($result);
    echo $row[0];
}
else
{
    echo "You are not an admin!";
}
?>
</html>